CREATE TABLE STREET_CATEGORY

(CAT varchar(50) CONSTRAINT ST_PK PRIMARY KEY,

DESCRIPTION nchar(100) NOT NULL)

-- Sample insert statements

INSERT INTO STREET_CATEGORY VALUES('HIGHWAY', 'HIGHWAY')

INSERT INTO STREET_CATEGORY VALUES('PRIMARY', 'PRIMARY')

INSERT INTO STREET_CATEGORY VALUES('SECONDARY', 'SECONDARY')

INSERT INTO STREET_CATEGORY VALUES('UNPAVED', 'UNPAVED')

ALTER TABLE STREET WITH CHECK ADD CONSTRAINT FK_STREET_CAT FOREIGN KEY(STREET_CAT)

REFERENCES STREET_CATEGORY (CAT);